﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="CDmDjkOrderRoute" targetNamespace="http://tempuri.org/CDmDjkOrderRoute.xsd" xmlns:mstns="http://tempuri.org/CDmDjkOrderRoute.xsd" xmlns="http://tempuri.org/CDmDjkOrderRoute.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="dijiekeConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="dijiekeConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.msBsc.Xsd.DataTds.Properties.Settings.GlobalReference.Default.dijiekeConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DJK_ORDER_ROUTETableAdapter" GeneratorDataComponentClassName="DJK_ORDER_ROUTETableAdapter" Name="DJK_ORDER_ROUTE" UserDataComponentName="DJK_ORDER_ROUTETableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dijiekeConnectionString (Settings)" DbObjectName="dijieke.dbo.DJK_ORDER_ROUTE" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[DJK_ORDER_ROUTE] WHERE (([ORDER_ROUTE_ID] = @Original_ORDER_ROUTE_ID) AND ((@IsNull_ORDER_ROUTE_NME = 1 AND [ORDER_ROUTE_NME] IS NULL) OR ([ORDER_ROUTE_NME] = @Original_ORDER_ROUTE_NME)) AND ((@IsNull_ORDER_ROUTE_INTRO = 1 AND [ORDER_ROUTE_INTRO] IS NULL) OR ([ORDER_ROUTE_INTRO] = @Original_ORDER_ROUTE_INTRO)) AND ((@IsNull_ORDER_ROUTE_DAYS = 1 AND [ORDER_ROUTE_DAYS] IS NULL) OR ([ORDER_ROUTE_DAYS] = @Original_ORDER_ROUTE_DAYS)) AND ((@IsNull_ROUTE_SCENIC_NUM = 1 AND [ROUTE_SCENIC_NUM] IS NULL) OR ([ROUTE_SCENIC_NUM] = @Original_ROUTE_SCENIC_NUM)) AND ((@IsNull_ROUTE_START_SCENIC = 1 AND [ROUTE_START_SCENIC] IS NULL) OR ([ROUTE_START_SCENIC] = @Original_ROUTE_START_SCENIC)) AND ((@IsNull_ROUTE_START_NME = 1 AND [ROUTE_START_NME] IS NULL) OR ([ROUTE_START_NME] = @Original_ROUTE_START_NME)) AND ((@IsNull_ROUTE_END_SCENIC = 1 AND [ROUTE_END_SCENIC] IS NULL) OR ([ROUTE_END_SCENIC] = @Original_ROUTE_END_SCENIC)) AND ((@IsNull_ROUTE_END_NME = 1 AND [ROUTE_END_NME] IS NULL) OR ([ROUTE_END_NME] = @Original_ROUTE_END_NME)) AND ((@IsNull_COUNTRY_ID = 1 AND [COUNTRY_ID] IS NULL) OR ([COUNTRY_ID] = @Original_COUNTRY_ID)) AND ((@IsNull_COUNTRY_NME = 1 AND [COUNTRY_NME] IS NULL) OR ([COUNTRY_NME] = @Original_COUNTRY_NME)) AND ((@IsNull_CITY_ID = 1 AND [CITY_ID] IS NULL) OR ([CITY_ID] = @Original_CITY_ID)) AND ((@IsNull_CITY_NME = 1 AND [CITY_NME] IS NULL) OR ([CITY_NME] = @Original_CITY_NME)) AND ((@IsNull_DESTINATION_ID = 1 AND [DESTINATION_ID] IS NULL) OR ([DESTINATION_ID] = @Original_DESTINATION_ID)) AND ((@IsNull_DESTINATION_NME = 1 AND [DESTINATION_NME] IS NULL) OR ([DESTINATION_NME] = @Original_DESTINATION_NME)) AND ((@IsNull_ROUTE_DEFAULT_PRICE = 1 AND [ROUTE_DEFAULT_PRICE] IS NULL) OR ([ROUTE_DEFAULT_PRICE] = @Original_ROUTE_DEFAULT_PRICE)) AND ((@IsNull_ROUTE_ORDER_EXPIRE = 1 AND [ROUTE_ORDER_EXPIRE] IS NULL) OR ([ROUTE_ORDER_EXPIRE] = @Original_ROUTE_ORDER_EXPIRE)) AND ((@IsNull_ROUTE_BASEINFO_RMK = 1 AND [ROUTE_BASEINFO_RMK] IS NULL) OR ([ROUTE_BASEINFO_RMK] = @Original_ROUTE_BASEINFO_RMK)) AND ((@IsNull_ROUTE_IS_SHOW = 1 AND [ROUTE_IS_SHOW] IS NULL) OR ([ROUTE_IS_SHOW] = @Original_ROUTE_IS_SHOW)) AND ((@IsNull_ROUTE_INFO_STATUS = 1 AND [ROUTE_INFO_STATUS] IS NULL) OR ([ROUTE_INFO_STATUS] = @Original_ROUTE_INFO_STATUS)) AND ((@IsNull_ROUTE_IS_VALID = 1 AND [ROUTE_IS_VALID] IS NULL) OR ([ROUTE_IS_VALID] = @Original_ROUTE_IS_VALID)) AND ((@IsNull_CREATE_ID = 1 AND [CREATE_ID] IS NULL) OR ([CREATE_ID] = @Original_CREATE_ID)) AND ((@IsNull_CREATE_DT = 1 AND [CREATE_DT] IS NULL) OR ([CREATE_DT] = @Original_CREATE_DT)) AND ((@IsNull_MODIFY_ID = 1 AND [MODIFY_ID] IS NULL) OR ([MODIFY_ID] = @Original_MODIFY_ID)) AND ((@IsNull_MODIFY_DT = 1 AND [MODIFY_DT] IS NULL) OR ([MODIFY_DT] = @Original_MODIFY_DT)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_ROUTE_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_ROUTE_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_ROUTE_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_ROUTE_INTRO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_INTRO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_ROUTE_INTRO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_INTRO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_ROUTE_DAYS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_DAYS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ORDER_ROUTE_DAYS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_DAYS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_SCENIC_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_SCENIC_NUM" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ROUTE_SCENIC_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_SCENIC_NUM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_START_SCENIC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_START_SCENIC" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ROUTE_START_SCENIC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ROUTE_START_SCENIC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_START_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_START_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ROUTE_START_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ROUTE_START_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_END_SCENIC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_END_SCENIC" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ROUTE_END_SCENIC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ROUTE_END_SCENIC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_END_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_END_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ROUTE_END_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ROUTE_END_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_COUNTRY_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="COUNTRY_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_COUNTRY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COUNTRY_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_COUNTRY_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="COUNTRY_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_COUNTRY_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COUNTRY_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CITY_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CITY_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CITY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CITY_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CITY_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CITY_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CITY_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CITY_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DESTINATION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DESTINATION_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DESTINATION_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DESTINATION_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DESTINATION_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DESTINATION_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DESTINATION_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DESTINATION_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_DEFAULT_PRICE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_DEFAULT_PRICE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ROUTE_DEFAULT_PRICE" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ROUTE_DEFAULT_PRICE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_ORDER_EXPIRE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_ORDER_EXPIRE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ROUTE_ORDER_EXPIRE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ROUTE_ORDER_EXPIRE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_BASEINFO_RMK" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_BASEINFO_RMK" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ROUTE_BASEINFO_RMK" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ROUTE_BASEINFO_RMK" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_IS_SHOW" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_IS_SHOW" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ROUTE_IS_SHOW" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_IS_SHOW" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_INFO_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_INFO_STATUS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ROUTE_INFO_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_INFO_STATUS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_IS_VALID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_IS_VALID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ROUTE_IS_VALID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_IS_VALID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CREATE_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CREATE_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CREATE_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CREATE_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CREATE_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CREATE_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CREATE_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CREATE_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFY_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFY_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MODIFY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MODIFY_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFY_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFY_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_MODIFY_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFY_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DJK_ORDER_ROUTE] ([ORDER_ROUTE_ID], [ORDER_ROUTE_NME], [ORDER_ROUTE_INTRO], [ORDER_ROUTE_DAYS], [ROUTE_SCENIC_NUM], [ROUTE_START_SCENIC], [ROUTE_START_NME], [ROUTE_END_SCENIC], [ROUTE_END_NME], [COUNTRY_ID], [COUNTRY_NME], [CITY_ID], [CITY_NME], [DESTINATION_ID], [DESTINATION_NME], [ROUTE_DEFAULT_PRICE], [ROUTE_ORDER_EXPIRE], [ROUTE_BASEINFO_RMK], [ROUTE_IS_SHOW], [ROUTE_INFO_STATUS], [ROUTE_IS_VALID], [CREATE_ID], [CREATE_DT], [MODIFY_ID], [MODIFY_DT]) VALUES (@ORDER_ROUTE_ID, @ORDER_ROUTE_NME, @ORDER_ROUTE_INTRO, @ORDER_ROUTE_DAYS, @ROUTE_SCENIC_NUM, @ROUTE_START_SCENIC, @ROUTE_START_NME, @ROUTE_END_SCENIC, @ROUTE_END_NME, @COUNTRY_ID, @COUNTRY_NME, @CITY_ID, @CITY_NME, @DESTINATION_ID, @DESTINATION_NME, @ROUTE_DEFAULT_PRICE, @ROUTE_ORDER_EXPIRE, @ROUTE_BASEINFO_RMK, @ROUTE_IS_SHOW, @ROUTE_INFO_STATUS, @ROUTE_IS_VALID, @CREATE_ID, @CREATE_DT, @MODIFY_ID, @MODIFY_DT);
SELECT ORDER_ROUTE_ID, ORDER_ROUTE_NME, ORDER_ROUTE_INTRO, ORDER_ROUTE_DAYS, ROUTE_SCENIC_NUM, ROUTE_START_SCENIC, ROUTE_START_NME, ROUTE_END_SCENIC, ROUTE_END_NME, COUNTRY_ID, COUNTRY_NME, CITY_ID, CITY_NME, DESTINATION_ID, DESTINATION_NME, ROUTE_DEFAULT_PRICE, ROUTE_ORDER_EXPIRE, ROUTE_BASEINFO_RMK, ROUTE_IS_SHOW, ROUTE_INFO_STATUS, ROUTE_IS_VALID, CREATE_ID, CREATE_DT, MODIFY_ID, MODIFY_DT FROM DJK_ORDER_ROUTE WHERE (ORDER_ROUTE_ID = @ORDER_ROUTE_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_ROUTE_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_ROUTE_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_ROUTE_INTRO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_INTRO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ORDER_ROUTE_DAYS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_DAYS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ROUTE_SCENIC_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_SCENIC_NUM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ROUTE_START_SCENIC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ROUTE_START_SCENIC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ROUTE_START_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ROUTE_START_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ROUTE_END_SCENIC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ROUTE_END_SCENIC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ROUTE_END_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ROUTE_END_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@COUNTRY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COUNTRY_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@COUNTRY_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COUNTRY_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CITY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CITY_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CITY_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CITY_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DESTINATION_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DESTINATION_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DESTINATION_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DESTINATION_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ROUTE_DEFAULT_PRICE" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ROUTE_DEFAULT_PRICE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ROUTE_ORDER_EXPIRE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ROUTE_ORDER_EXPIRE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ROUTE_BASEINFO_RMK" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ROUTE_BASEINFO_RMK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ROUTE_IS_SHOW" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_IS_SHOW" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ROUTE_INFO_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_INFO_STATUS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ROUTE_IS_VALID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_IS_VALID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CREATE_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CREATE_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CREATE_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CREATE_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MODIFY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MODIFY_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MODIFY_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFY_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ORDER_ROUTE_ID, ORDER_ROUTE_NME, ORDER_ROUTE_INTRO, ORDER_ROUTE_DAYS, ROUTE_SCENIC_NUM, ROUTE_START_SCENIC, ROUTE_START_NME, ROUTE_END_SCENIC, ROUTE_END_NME, COUNTRY_ID, COUNTRY_NME, CITY_ID, CITY_NME, DESTINATION_ID, DESTINATION_NME, ROUTE_DEFAULT_PRICE, ROUTE_ORDER_EXPIRE, ROUTE_BASEINFO_RMK, ROUTE_IS_SHOW, ROUTE_INFO_STATUS, ROUTE_IS_VALID, CREATE_ID, CREATE_DT, MODIFY_ID, MODIFY_DT FROM dbo.DJK_ORDER_ROUTE</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[DJK_ORDER_ROUTE] SET [ORDER_ROUTE_ID] = @ORDER_ROUTE_ID, [ORDER_ROUTE_NME] = @ORDER_ROUTE_NME, [ORDER_ROUTE_INTRO] = @ORDER_ROUTE_INTRO, [ORDER_ROUTE_DAYS] = @ORDER_ROUTE_DAYS, [ROUTE_SCENIC_NUM] = @ROUTE_SCENIC_NUM, [ROUTE_START_SCENIC] = @ROUTE_START_SCENIC, [ROUTE_START_NME] = @ROUTE_START_NME, [ROUTE_END_SCENIC] = @ROUTE_END_SCENIC, [ROUTE_END_NME] = @ROUTE_END_NME, [COUNTRY_ID] = @COUNTRY_ID, [COUNTRY_NME] = @COUNTRY_NME, [CITY_ID] = @CITY_ID, [CITY_NME] = @CITY_NME, [DESTINATION_ID] = @DESTINATION_ID, [DESTINATION_NME] = @DESTINATION_NME, [ROUTE_DEFAULT_PRICE] = @ROUTE_DEFAULT_PRICE, [ROUTE_ORDER_EXPIRE] = @ROUTE_ORDER_EXPIRE, [ROUTE_BASEINFO_RMK] = @ROUTE_BASEINFO_RMK, [ROUTE_IS_SHOW] = @ROUTE_IS_SHOW, [ROUTE_INFO_STATUS] = @ROUTE_INFO_STATUS, [ROUTE_IS_VALID] = @ROUTE_IS_VALID, [CREATE_ID] = @CREATE_ID, [CREATE_DT] = @CREATE_DT, [MODIFY_ID] = @MODIFY_ID, [MODIFY_DT] = @MODIFY_DT WHERE (([ORDER_ROUTE_ID] = @Original_ORDER_ROUTE_ID) AND ((@IsNull_ORDER_ROUTE_NME = 1 AND [ORDER_ROUTE_NME] IS NULL) OR ([ORDER_ROUTE_NME] = @Original_ORDER_ROUTE_NME)) AND ((@IsNull_ORDER_ROUTE_INTRO = 1 AND [ORDER_ROUTE_INTRO] IS NULL) OR ([ORDER_ROUTE_INTRO] = @Original_ORDER_ROUTE_INTRO)) AND ((@IsNull_ORDER_ROUTE_DAYS = 1 AND [ORDER_ROUTE_DAYS] IS NULL) OR ([ORDER_ROUTE_DAYS] = @Original_ORDER_ROUTE_DAYS)) AND ((@IsNull_ROUTE_SCENIC_NUM = 1 AND [ROUTE_SCENIC_NUM] IS NULL) OR ([ROUTE_SCENIC_NUM] = @Original_ROUTE_SCENIC_NUM)) AND ((@IsNull_ROUTE_START_SCENIC = 1 AND [ROUTE_START_SCENIC] IS NULL) OR ([ROUTE_START_SCENIC] = @Original_ROUTE_START_SCENIC)) AND ((@IsNull_ROUTE_START_NME = 1 AND [ROUTE_START_NME] IS NULL) OR ([ROUTE_START_NME] = @Original_ROUTE_START_NME)) AND ((@IsNull_ROUTE_END_SCENIC = 1 AND [ROUTE_END_SCENIC] IS NULL) OR ([ROUTE_END_SCENIC] = @Original_ROUTE_END_SCENIC)) AND ((@IsNull_ROUTE_END_NME = 1 AND [ROUTE_END_NME] IS NULL) OR ([ROUTE_END_NME] = @Original_ROUTE_END_NME)) AND ((@IsNull_COUNTRY_ID = 1 AND [COUNTRY_ID] IS NULL) OR ([COUNTRY_ID] = @Original_COUNTRY_ID)) AND ((@IsNull_COUNTRY_NME = 1 AND [COUNTRY_NME] IS NULL) OR ([COUNTRY_NME] = @Original_COUNTRY_NME)) AND ((@IsNull_CITY_ID = 1 AND [CITY_ID] IS NULL) OR ([CITY_ID] = @Original_CITY_ID)) AND ((@IsNull_CITY_NME = 1 AND [CITY_NME] IS NULL) OR ([CITY_NME] = @Original_CITY_NME)) AND ((@IsNull_DESTINATION_ID = 1 AND [DESTINATION_ID] IS NULL) OR ([DESTINATION_ID] = @Original_DESTINATION_ID)) AND ((@IsNull_DESTINATION_NME = 1 AND [DESTINATION_NME] IS NULL) OR ([DESTINATION_NME] = @Original_DESTINATION_NME)) AND ((@IsNull_ROUTE_DEFAULT_PRICE = 1 AND [ROUTE_DEFAULT_PRICE] IS NULL) OR ([ROUTE_DEFAULT_PRICE] = @Original_ROUTE_DEFAULT_PRICE)) AND ((@IsNull_ROUTE_ORDER_EXPIRE = 1 AND [ROUTE_ORDER_EXPIRE] IS NULL) OR ([ROUTE_ORDER_EXPIRE] = @Original_ROUTE_ORDER_EXPIRE)) AND ((@IsNull_ROUTE_BASEINFO_RMK = 1 AND [ROUTE_BASEINFO_RMK] IS NULL) OR ([ROUTE_BASEINFO_RMK] = @Original_ROUTE_BASEINFO_RMK)) AND ((@IsNull_ROUTE_IS_SHOW = 1 AND [ROUTE_IS_SHOW] IS NULL) OR ([ROUTE_IS_SHOW] = @Original_ROUTE_IS_SHOW)) AND ((@IsNull_ROUTE_INFO_STATUS = 1 AND [ROUTE_INFO_STATUS] IS NULL) OR ([ROUTE_INFO_STATUS] = @Original_ROUTE_INFO_STATUS)) AND ((@IsNull_ROUTE_IS_VALID = 1 AND [ROUTE_IS_VALID] IS NULL) OR ([ROUTE_IS_VALID] = @Original_ROUTE_IS_VALID)) AND ((@IsNull_CREATE_ID = 1 AND [CREATE_ID] IS NULL) OR ([CREATE_ID] = @Original_CREATE_ID)) AND ((@IsNull_CREATE_DT = 1 AND [CREATE_DT] IS NULL) OR ([CREATE_DT] = @Original_CREATE_DT)) AND ((@IsNull_MODIFY_ID = 1 AND [MODIFY_ID] IS NULL) OR ([MODIFY_ID] = @Original_MODIFY_ID)) AND ((@IsNull_MODIFY_DT = 1 AND [MODIFY_DT] IS NULL) OR ([MODIFY_DT] = @Original_MODIFY_DT)));
SELECT ORDER_ROUTE_ID, ORDER_ROUTE_NME, ORDER_ROUTE_INTRO, ORDER_ROUTE_DAYS, ROUTE_SCENIC_NUM, ROUTE_START_SCENIC, ROUTE_START_NME, ROUTE_END_SCENIC, ROUTE_END_NME, COUNTRY_ID, COUNTRY_NME, CITY_ID, CITY_NME, DESTINATION_ID, DESTINATION_NME, ROUTE_DEFAULT_PRICE, ROUTE_ORDER_EXPIRE, ROUTE_BASEINFO_RMK, ROUTE_IS_SHOW, ROUTE_INFO_STATUS, ROUTE_IS_VALID, CREATE_ID, CREATE_DT, MODIFY_ID, MODIFY_DT FROM DJK_ORDER_ROUTE WHERE (ORDER_ROUTE_ID = @ORDER_ROUTE_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_ROUTE_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_ROUTE_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_ROUTE_INTRO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_INTRO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ORDER_ROUTE_DAYS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_DAYS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ROUTE_SCENIC_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_SCENIC_NUM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ROUTE_START_SCENIC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ROUTE_START_SCENIC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ROUTE_START_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ROUTE_START_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ROUTE_END_SCENIC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ROUTE_END_SCENIC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ROUTE_END_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ROUTE_END_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@COUNTRY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COUNTRY_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@COUNTRY_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COUNTRY_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CITY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CITY_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CITY_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CITY_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DESTINATION_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DESTINATION_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DESTINATION_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DESTINATION_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ROUTE_DEFAULT_PRICE" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ROUTE_DEFAULT_PRICE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ROUTE_ORDER_EXPIRE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ROUTE_ORDER_EXPIRE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ROUTE_BASEINFO_RMK" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ROUTE_BASEINFO_RMK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ROUTE_IS_SHOW" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_IS_SHOW" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ROUTE_INFO_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_INFO_STATUS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ROUTE_IS_VALID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_IS_VALID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CREATE_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CREATE_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CREATE_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CREATE_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MODIFY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MODIFY_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MODIFY_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFY_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_ROUTE_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_ROUTE_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_ROUTE_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_ROUTE_INTRO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_INTRO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_ROUTE_INTRO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_INTRO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_ROUTE_DAYS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_DAYS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ORDER_ROUTE_DAYS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_ROUTE_DAYS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_SCENIC_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_SCENIC_NUM" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ROUTE_SCENIC_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_SCENIC_NUM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_START_SCENIC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_START_SCENIC" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ROUTE_START_SCENIC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ROUTE_START_SCENIC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_START_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_START_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ROUTE_START_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ROUTE_START_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_END_SCENIC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_END_SCENIC" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ROUTE_END_SCENIC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ROUTE_END_SCENIC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_END_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_END_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ROUTE_END_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ROUTE_END_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_COUNTRY_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="COUNTRY_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_COUNTRY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COUNTRY_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_COUNTRY_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="COUNTRY_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_COUNTRY_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COUNTRY_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CITY_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CITY_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CITY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CITY_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CITY_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CITY_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CITY_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CITY_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DESTINATION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DESTINATION_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DESTINATION_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DESTINATION_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DESTINATION_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DESTINATION_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DESTINATION_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DESTINATION_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_DEFAULT_PRICE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_DEFAULT_PRICE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ROUTE_DEFAULT_PRICE" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ROUTE_DEFAULT_PRICE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_ORDER_EXPIRE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_ORDER_EXPIRE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ROUTE_ORDER_EXPIRE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ROUTE_ORDER_EXPIRE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_BASEINFO_RMK" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_BASEINFO_RMK" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ROUTE_BASEINFO_RMK" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ROUTE_BASEINFO_RMK" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_IS_SHOW" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_IS_SHOW" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ROUTE_IS_SHOW" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_IS_SHOW" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_INFO_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_INFO_STATUS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ROUTE_INFO_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_INFO_STATUS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROUTE_IS_VALID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_IS_VALID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ROUTE_IS_VALID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROUTE_IS_VALID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CREATE_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CREATE_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CREATE_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CREATE_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CREATE_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CREATE_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CREATE_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CREATE_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFY_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFY_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MODIFY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MODIFY_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFY_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFY_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_MODIFY_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFY_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ORDER_ROUTE_ID" DataSetColumn="ORDER_ROUTE_ID" />
              <Mapping SourceColumn="ORDER_ROUTE_NME" DataSetColumn="ORDER_ROUTE_NME" />
              <Mapping SourceColumn="ORDER_ROUTE_INTRO" DataSetColumn="ORDER_ROUTE_INTRO" />
              <Mapping SourceColumn="ORDER_ROUTE_DAYS" DataSetColumn="ORDER_ROUTE_DAYS" />
              <Mapping SourceColumn="ROUTE_SCENIC_NUM" DataSetColumn="ROUTE_SCENIC_NUM" />
              <Mapping SourceColumn="ROUTE_START_SCENIC" DataSetColumn="ROUTE_START_SCENIC" />
              <Mapping SourceColumn="ROUTE_START_NME" DataSetColumn="ROUTE_START_NME" />
              <Mapping SourceColumn="ROUTE_END_SCENIC" DataSetColumn="ROUTE_END_SCENIC" />
              <Mapping SourceColumn="ROUTE_END_NME" DataSetColumn="ROUTE_END_NME" />
              <Mapping SourceColumn="COUNTRY_ID" DataSetColumn="COUNTRY_ID" />
              <Mapping SourceColumn="COUNTRY_NME" DataSetColumn="COUNTRY_NME" />
              <Mapping SourceColumn="CITY_ID" DataSetColumn="CITY_ID" />
              <Mapping SourceColumn="CITY_NME" DataSetColumn="CITY_NME" />
              <Mapping SourceColumn="DESTINATION_ID" DataSetColumn="DESTINATION_ID" />
              <Mapping SourceColumn="DESTINATION_NME" DataSetColumn="DESTINATION_NME" />
              <Mapping SourceColumn="ROUTE_DEFAULT_PRICE" DataSetColumn="ROUTE_DEFAULT_PRICE" />
              <Mapping SourceColumn="ROUTE_ORDER_EXPIRE" DataSetColumn="ROUTE_ORDER_EXPIRE" />
              <Mapping SourceColumn="ROUTE_BASEINFO_RMK" DataSetColumn="ROUTE_BASEINFO_RMK" />
              <Mapping SourceColumn="ROUTE_IS_SHOW" DataSetColumn="ROUTE_IS_SHOW" />
              <Mapping SourceColumn="ROUTE_INFO_STATUS" DataSetColumn="ROUTE_INFO_STATUS" />
              <Mapping SourceColumn="ROUTE_IS_VALID" DataSetColumn="ROUTE_IS_VALID" />
              <Mapping SourceColumn="CREATE_ID" DataSetColumn="CREATE_ID" />
              <Mapping SourceColumn="CREATE_DT" DataSetColumn="CREATE_DT" />
              <Mapping SourceColumn="MODIFY_ID" DataSetColumn="MODIFY_ID" />
              <Mapping SourceColumn="MODIFY_DT" DataSetColumn="MODIFY_DT" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="CDmDjkOrderRoute" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="CDmDjkOrderRoute" msprop:Generator_UserDSName="CDmDjkOrderRoute">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="DJK_ORDER_ROUTE" msprop:Generator_TableClassName="DJK_ORDER_ROUTEDataTable" msprop:Generator_TableVarName="tableDJK_ORDER_ROUTE" msprop:Generator_TablePropName="DJK_ORDER_ROUTE" msprop:Generator_RowDeletingName="DJK_ORDER_ROUTERowDeleting" msprop:Generator_RowChangingName="DJK_ORDER_ROUTERowChanging" msprop:Generator_RowEvHandlerName="DJK_ORDER_ROUTERowChangeEventHandler" msprop:Generator_RowDeletedName="DJK_ORDER_ROUTERowDeleted" msprop:Generator_UserTableName="DJK_ORDER_ROUTE" msprop:Generator_RowChangedName="DJK_ORDER_ROUTERowChanged" msprop:Generator_RowEvArgName="DJK_ORDER_ROUTERowChangeEvent" msprop:Generator_RowClassName="DJK_ORDER_ROUTERow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ORDER_ROUTE_ID" msprop:Generator_ColumnVarNameInTable="columnORDER_ROUTE_ID" msprop:Generator_ColumnPropNameInRow="ORDER_ROUTE_ID" msprop:Generator_ColumnPropNameInTable="ORDER_ROUTE_IDColumn" msprop:Generator_UserColumnName="ORDER_ROUTE_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ORDER_ROUTE_NME" msprop:Generator_ColumnVarNameInTable="columnORDER_ROUTE_NME" msprop:Generator_ColumnPropNameInRow="ORDER_ROUTE_NME" msprop:Generator_ColumnPropNameInTable="ORDER_ROUTE_NMEColumn" msprop:Generator_UserColumnName="ORDER_ROUTE_NME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="128" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ORDER_ROUTE_INTRO" msprop:Generator_ColumnVarNameInTable="columnORDER_ROUTE_INTRO" msprop:Generator_ColumnPropNameInRow="ORDER_ROUTE_INTRO" msprop:Generator_ColumnPropNameInTable="ORDER_ROUTE_INTROColumn" msprop:Generator_UserColumnName="ORDER_ROUTE_INTRO" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="512" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ORDER_ROUTE_DAYS" msprop:Generator_ColumnVarNameInTable="columnORDER_ROUTE_DAYS" msprop:Generator_ColumnPropNameInRow="ORDER_ROUTE_DAYS" msprop:Generator_ColumnPropNameInTable="ORDER_ROUTE_DAYSColumn" msprop:Generator_UserColumnName="ORDER_ROUTE_DAYS" type="xs:int" minOccurs="0" />
              <xs:element name="ROUTE_SCENIC_NUM" msprop:Generator_ColumnVarNameInTable="columnROUTE_SCENIC_NUM" msprop:Generator_ColumnPropNameInRow="ROUTE_SCENIC_NUM" msprop:Generator_ColumnPropNameInTable="ROUTE_SCENIC_NUMColumn" msprop:Generator_UserColumnName="ROUTE_SCENIC_NUM" type="xs:int" minOccurs="0" />
              <xs:element name="ROUTE_START_SCENIC" msprop:Generator_ColumnVarNameInTable="columnROUTE_START_SCENIC" msprop:Generator_ColumnPropNameInRow="ROUTE_START_SCENIC" msprop:Generator_ColumnPropNameInTable="ROUTE_START_SCENICColumn" msprop:Generator_UserColumnName="ROUTE_START_SCENIC" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ROUTE_START_NME" msprop:Generator_ColumnVarNameInTable="columnROUTE_START_NME" msprop:Generator_ColumnPropNameInRow="ROUTE_START_NME" msprop:Generator_ColumnPropNameInTable="ROUTE_START_NMEColumn" msprop:Generator_UserColumnName="ROUTE_START_NME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ROUTE_END_SCENIC" msprop:Generator_ColumnVarNameInTable="columnROUTE_END_SCENIC" msprop:Generator_ColumnPropNameInRow="ROUTE_END_SCENIC" msprop:Generator_ColumnPropNameInTable="ROUTE_END_SCENICColumn" msprop:Generator_UserColumnName="ROUTE_END_SCENIC" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ROUTE_END_NME" msprop:Generator_ColumnVarNameInTable="columnROUTE_END_NME" msprop:Generator_ColumnPropNameInRow="ROUTE_END_NME" msprop:Generator_ColumnPropNameInTable="ROUTE_END_NMEColumn" msprop:Generator_UserColumnName="ROUTE_END_NME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="COUNTRY_ID" msprop:Generator_ColumnVarNameInTable="columnCOUNTRY_ID" msprop:Generator_ColumnPropNameInRow="COUNTRY_ID" msprop:Generator_ColumnPropNameInTable="COUNTRY_IDColumn" msprop:Generator_UserColumnName="COUNTRY_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="COUNTRY_NME" msprop:Generator_ColumnVarNameInTable="columnCOUNTRY_NME" msprop:Generator_ColumnPropNameInRow="COUNTRY_NME" msprop:Generator_ColumnPropNameInTable="COUNTRY_NMEColumn" msprop:Generator_UserColumnName="COUNTRY_NME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CITY_ID" msprop:Generator_ColumnVarNameInTable="columnCITY_ID" msprop:Generator_ColumnPropNameInRow="CITY_ID" msprop:Generator_ColumnPropNameInTable="CITY_IDColumn" msprop:Generator_UserColumnName="CITY_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CITY_NME" msprop:Generator_ColumnVarNameInTable="columnCITY_NME" msprop:Generator_ColumnPropNameInRow="CITY_NME" msprop:Generator_ColumnPropNameInTable="CITY_NMEColumn" msprop:Generator_UserColumnName="CITY_NME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DESTINATION_ID" msprop:Generator_ColumnVarNameInTable="columnDESTINATION_ID" msprop:Generator_ColumnPropNameInRow="DESTINATION_ID" msprop:Generator_ColumnPropNameInTable="DESTINATION_IDColumn" msprop:Generator_UserColumnName="DESTINATION_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DESTINATION_NME" msprop:Generator_ColumnVarNameInTable="columnDESTINATION_NME" msprop:Generator_ColumnPropNameInRow="DESTINATION_NME" msprop:Generator_ColumnPropNameInTable="DESTINATION_NMEColumn" msprop:Generator_UserColumnName="DESTINATION_NME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ROUTE_DEFAULT_PRICE" msprop:Generator_ColumnVarNameInTable="columnROUTE_DEFAULT_PRICE" msprop:Generator_ColumnPropNameInRow="ROUTE_DEFAULT_PRICE" msprop:Generator_ColumnPropNameInTable="ROUTE_DEFAULT_PRICEColumn" msprop:Generator_UserColumnName="ROUTE_DEFAULT_PRICE" type="xs:decimal" minOccurs="0" />
              <xs:element name="ROUTE_ORDER_EXPIRE" msprop:Generator_ColumnVarNameInTable="columnROUTE_ORDER_EXPIRE" msprop:Generator_ColumnPropNameInRow="ROUTE_ORDER_EXPIRE" msprop:Generator_ColumnPropNameInTable="ROUTE_ORDER_EXPIREColumn" msprop:Generator_UserColumnName="ROUTE_ORDER_EXPIRE" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ROUTE_BASEINFO_RMK" msprop:Generator_ColumnVarNameInTable="columnROUTE_BASEINFO_RMK" msprop:Generator_ColumnPropNameInRow="ROUTE_BASEINFO_RMK" msprop:Generator_ColumnPropNameInTable="ROUTE_BASEINFO_RMKColumn" msprop:Generator_UserColumnName="ROUTE_BASEINFO_RMK" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ROUTE_IS_SHOW" msprop:Generator_ColumnVarNameInTable="columnROUTE_IS_SHOW" msprop:Generator_ColumnPropNameInRow="ROUTE_IS_SHOW" msprop:Generator_ColumnPropNameInTable="ROUTE_IS_SHOWColumn" msprop:Generator_UserColumnName="ROUTE_IS_SHOW" type="xs:int" minOccurs="0" />
              <xs:element name="ROUTE_INFO_STATUS" msprop:Generator_ColumnVarNameInTable="columnROUTE_INFO_STATUS" msprop:Generator_ColumnPropNameInRow="ROUTE_INFO_STATUS" msprop:Generator_ColumnPropNameInTable="ROUTE_INFO_STATUSColumn" msprop:Generator_UserColumnName="ROUTE_INFO_STATUS" type="xs:int" minOccurs="0" />
              <xs:element name="ROUTE_IS_VALID" msprop:Generator_ColumnVarNameInTable="columnROUTE_IS_VALID" msprop:Generator_ColumnPropNameInRow="ROUTE_IS_VALID" msprop:Generator_ColumnPropNameInTable="ROUTE_IS_VALIDColumn" msprop:Generator_UserColumnName="ROUTE_IS_VALID" type="xs:int" minOccurs="0" />
              <xs:element name="CREATE_ID" msprop:Generator_ColumnVarNameInTable="columnCREATE_ID" msprop:Generator_ColumnPropNameInRow="CREATE_ID" msprop:Generator_ColumnPropNameInTable="CREATE_IDColumn" msprop:Generator_UserColumnName="CREATE_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CREATE_DT" msprop:Generator_ColumnVarNameInTable="columnCREATE_DT" msprop:Generator_ColumnPropNameInRow="CREATE_DT" msprop:Generator_ColumnPropNameInTable="CREATE_DTColumn" msprop:Generator_UserColumnName="CREATE_DT" type="xs:dateTime" minOccurs="0" />
              <xs:element name="MODIFY_ID" msprop:Generator_ColumnVarNameInTable="columnMODIFY_ID" msprop:Generator_ColumnPropNameInRow="MODIFY_ID" msprop:Generator_ColumnPropNameInTable="MODIFY_IDColumn" msprop:Generator_UserColumnName="MODIFY_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MODIFY_DT" msprop:Generator_ColumnVarNameInTable="columnMODIFY_DT" msprop:Generator_ColumnPropNameInRow="MODIFY_DT" msprop:Generator_ColumnPropNameInTable="MODIFY_DTColumn" msprop:Generator_UserColumnName="MODIFY_DT" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DJK_ORDER_ROUTE" />
      <xs:field xpath="mstns:ORDER_ROUTE_ID" />
    </xs:unique>
  </xs:element>
</xs:schema>